To build a query
1. (Optional) Build the look up table that you want to use to manage the value in SQL Server.
2. Build the query that will define the look up table. Be sure that the Display tab displays the code value as well as the expanded description.
3. Save the query in the Document System in Common > Queries > Value Lists.
To select values to display for a property
1. From Tools > Business object designer, select your object from the list and click Edit.
2. On the Properties tab, select the property that needs values and select the Values sub-tab.
3. Select the Query Object option.
4. Browse and select the query you saved.
5. Define the Data Value to match the code that exists in the data
6. Define the Display Value to match the expanded description that describes the Data Value.
7. Click Save and Publish. Any messages should state that there are no errors.
8. Test your changes by writing a query against the object, selecting the property on the Filters tab, and confirming that it now includes a Value list.